package com.ums.scumspay.bigdataimport.QryFile;



import com.ums.scumspay.bigdataimport.constant.FilePathConstant;

import java.io.*;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;

/**
 * 类名 Achievements
 * 作者 LYC
 * 时间 2022.08.23 2022/8/23 15:52
 * 描述：处理部门绩效的文件
 */
public class Achievements {
    String newFile="F:\\bigdata\\Ins202301_02.sql";
    public static void main(String[] args) throws IOException {
        Achievements achievements=new Achievements();
        //achievements.ReadFile("H:\\temp\\部门财务指标\\2022年1-10月收入、成本、费用结构分类-按新分类(模板）(1).xlsx");
        achievements.ReadFile("F:\\bigdata\\temp\\2023年1-4月收入、成本、费用结构分类-按新分类 - 副本.xlsx");
        //achievements.ReadFile("F:\\bigdata\\temp\\2023年1-4月收入、成本、费用结构分类-按新分类.xlsx");

    }
    /**
     * 作者 LYC
     * 时间 2022/8/23 15:53
     * 参数 [filePath]
     * 返回值 void
     *方法描述：读取综合部文件进行数据处理
     **/
    public void ReadFile(String filePath)  {
        try{
            HashMap<String, ArrayList<ArrayList<String>>> map=ExecUtil.readExcel(new File(filePath),1);
            File newfile = new File(FilePathConstant.filePath+"\\prod_"+new SimpleDateFormat("yyyyMMdd").format(new Date())+".sql");
            BufferedWriter out = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(newfile), "UTF-8"));
            //处理sheet0 收入
            //  sheetSR(map.get("sheet0"),out);
             // sheetcb(map.get("sheet1"),out);
              // sheetfy(map.get("sheet2"),out);
//                 sheetqncpjj(map.get("sheet3"),out);
           sheetqntq(map.get("sheet0"),out);
        }catch (Exception e){
            e.printStackTrace();
        }


    }

    /**
     * 作者 LYC
     * 时间 2022/8/23 18:12
     * 参数 [list]
    * 返回值 void
     *方法描述：成本
    **/
    public static void sheetcb(ArrayList<ArrayList<String>> list,BufferedWriter out) throws IOException {
        for (int i = 5; i < list.size(); i++) {
            System.out.println("************"+i);
            ArrayList<String> array=list.get(i);
            for (int j = 0; j < array.size(); j++) {

//
//                //成本-支付银行-线下支付-品牌费
                if(j==1 &j<=13) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','线下支付','品牌费'," +
                            "'" + array.get(1) + "'," +
                            "'" + array.get(2) + "'," +
                            "'" + array.get(3) + "'," +
                            "'" + array.get(4) + "'," +
                            "'" + array.get(5) + "'," +
                            "'" + array.get(6) + "'," +
                            "'" + array.get(7) + "'," +
                            "'" + array.get(8) + "'," +
                            "'" + array.get(9) + "'," +
                            "'" + array.get(10) + "'," +
                            "'" + array.get(11) + "'," +
                            "'" + array.get(12) + "'," +
                            "'" + array.get(13) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-支付银行-线下支付-财税库银
                if(j==14 &j<=26) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','线下支付','财税库银'," +
                            "'" + array.get(14) + "'," +
                            "'" + array.get(15) + "'," +
                            "'" + array.get(16) + "'," +
                            "'" + array.get(17) + "'," +
                            "'" + array.get(18) + "'," +
                            "'" + array.get(19) + "'," +
                            "'" + array.get(20) + "'," +
                            "'" + array.get(21) + "'," +
                            "'" + array.get(22) + "'," +
                            "'" + array.get(23) + "'," +
                            "'" + array.get(24) + "'," +
                            "'" + array.get(25) + "'," +
                            "'" + array.get(26) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-支付银行-线下支付-分润成本
                if(j==27 &j<=39) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','线下支付','分润成本'," +
                            "'" + array.get(27) + "'," +
                            "'" + array.get(28) + "'," +
                            "'" + array.get(29) + "'," +
                            "'" + array.get(30) + "'," +
                            "'" + array.get(31) + "'," +
                            "'" + array.get(32) + "'," +
                            "'" + array.get(33) + "'," +
                            "'" + array.get(34) + "'," +
                            "'" + array.get(35) + "'," +
                            "'" + array.get(36) + "'," +
                            "'" + array.get(37) + "'," +
                            "'" + array.get(38) + "'," +
                            "'" + array.get(39) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-支付银行-线下支付-预付卡
                if(j==40 &j<=52) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','线下支付','预付卡'," +
                            "'" + array.get(40) + "'," +
                            "'" + array.get(41) + "'," +
                            "'" + array.get(42) + "'," +
                            "'" + array.get(43) + "'," +
                            "'" + array.get(44) + "'," +
                            "'" + array.get(45) + "'," +
                            "'" + array.get(46) + "'," +
                            "'" + array.get(47) + "'," +
                            "'" + array.get(48) + "'," +
                            "'" + array.get(49) + "'," +
                            "'" + array.get(50) + "'," +
                            "'" + array.get(51) + "'," +
                            "'" + array.get(52) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-支付银行-线下支付-机具折旧等
                if(j==53 &j<=65) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','线下支付','机具折旧等'," +
                            "'" + array.get(53) + "'," +
                            "'" + array.get(54) + "'," +
                            "'" + array.get(55) + "'," +
                            "'" + array.get(56) + "'," +
                            "'" + array.get(57) + "'," +
                            "'" + array.get(58) + "'," +
                            "'" + array.get(59) + "'," +
                            "'" + array.get(60) + "'," +
                            "'" + array.get(61) + "'," +
                            "'" + array.get(62) + "'," +
                            "'" + array.get(63) + "'," +
                            "'" + array.get(64) + "'," +
                            "'" + array.get(65) + "'); ");	out.newLine(); out.flush();
                }

                if(j==66 &j<=78) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','线下支付','签购单'," +
                            "'" + array.get(66) + "'," +
                            "'" + array.get(67) + "'," +
                            "'" + array.get(68) + "'," +
                            "'" + array.get(69) + "'," +
                            "'" + array.get(70) + "'," +
                            "'" + array.get(71) + "'," +
                            "'" + array.get(72) + "'," +
                            "'" + array.get(73) + "'," +
                            "'" + array.get(74) + "'," +
                            "'" + array.get(75) + "'," +
                            "'" + array.get(76) + "'," +
                            "'" + array.get(77) + "'," +
                            "'" + array.get(78) + "'); ");	out.newLine(); out.flush();
                }
                //成本-支付银行-增值银商-通讯成本等
                if(j==79 &j<=91) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','增值银商','通讯成本等',"  +
                            "'" + array.get(79) + "'," +
                            "'" + array.get(80) + "'," +
                            "'" + array.get(81) + "'," +
                            "'" + array.get(82) + "'," +
                            "'" + array.get(83) + "'," +
                            "'" + array.get(84) + "'," +
                            "'" + array.get(85) + "'," +
                            "'" + array.get(86) + "'," +
                            "'" + array.get(87) + "'," +
                            "'" + array.get(88) + "'," +
                            "'" + array.get(89) + "'," +
                            "'" + array.get(90) + "'," +
                            "'" + array.get(91) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-支付银行-线上支付-财税库银

//                //成本-支付银行-线上支付-财税库银
                if(j==92 &j<=104) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','线上支付','财税库银'," +
                            "'" + array.get(92) + "'," +
                            "'" + array.get(93) + "'," +
                            "'" + array.get(94) + "'," +
                            "'" + array.get(95) + "'," +
                            "'" + array.get(96) + "'," +
                            "'" + array.get(97) + "'," +
                            "'" + array.get(98) + "'," +
                            "'" + array.get(99) + "'," +
                            "'" + array.get(100) + "'," +
                            "'" + array.get(101) + "'," +
                            "'" + array.get(102) + "'," +
                            "'" + array.get(103) + "'," +
                            "'" + array.get(104) + "'); ");
                    out.newLine();
                    out.flush();
                }
//                //成本--线上支付-代收付
                if(j==105 &j<=117) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','支付银商','线上支付','代收付'," +
                            "'" + array.get(105) + "'," +
                            "'" + array.get(106) + "'," +
                            "'" + array.get(107) + "'," +
                            "'" + array.get(108) + "'," +
                            "'" + array.get(109) + "'," +
                            "'" + array.get(110) + "'," +
                            "'" + array.get(111) + "'," +
                            "'" + array.get(112) + "'," +
                            "'" + array.get(113) + "'," +
                            "'" + array.get(114) + "'," +
                            "'" + array.get(115) + "'," +
                            "'" + array.get(116) + "'," +
                            "'" + array.get(117) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-线上支付-发卡、银联网络服务费
                if(j==118 &j<=130) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','线上支付','发卡、银联网络服务费'," +
                            "'" + array.get(118) + "'," +
                            "'" + array.get(119) + "'," +
                            "'" + array.get(120) + "'," +
                            "'" + array.get(121) + "'," +
                            "'" + array.get(122) + "'," +
                            "'" + array.get(123) + "'," +
                            "'" + array.get(124) + "'," +
                            "'" + array.get(125) + "'," +
                            "'" + array.get(126) + "'," +
                            "'" + array.get(127) + "'," +
                            "'" + array.get(128) + "'," +
                            "'" + array.get(129) + "'," +
                            "'" + array.get(130) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-增值银商-拓展服务-耗材配件
                if(j==131 &j<=143) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','增值银商','耗材配件'," +
                            "'" + array.get(131) + "'," +
                            "'" + array.get(132) + "'," +
                            "'" + array.get(133) + "'," +
                            "'" + array.get(134) + "'," +
                            "'" + array.get(135) + "'," +
                            "'" + array.get(136) + "'," +
                            "'" + array.get(137) + "'," +
                            "'" + array.get(138) + "'," +
                            "'" + array.get(139) + "'," +
                            "'" + array.get(140) + "'," +
                            "'" + array.get(141) + "'," +
                            "'" + array.get(142) + "'," +
                            "'" + array.get(143) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-增值银商-拓展服务-其他
                if(j==144 &j<=156) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','增值银商','拓展服务-其他'," +
                            "'" + array.get(144) + "'," +
                            "'" + array.get(145) + "'," +
                            "'" + array.get(146) + "'," +
                            "'" + array.get(147) + "'," +
                            "'" + array.get(148) + "'," +
                            "'" + array.get(149) + "'," +
                            "'" + array.get(150) + "'," +
                            "'" + array.get(151) + "'," +
                            "'" + array.get(152) + "'," +
                            "'" + array.get(153) + "'," +
                            "'" + array.get(154) + "'," +
                            "'" + array.get(155) + "'," +
                            "'" + array.get(156) + "'); ");	out.newLine(); out.flush();
                }
//                //成本-增值银商-ATM专业化
                if(j==157 &j<=169) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','增值银商','ATM专业化'," +
                            "'" + array.get(157) + "'," +
                            "'" + array.get(158) + "'," +
                            "'" + array.get(159) + "'," +
                            "'" + array.get(160) + "'," +
                            "'" + array.get(161) + "'," +
                            "'" + array.get(162) + "'," +
                            "'" + array.get(163) + "'," +
                            "'" + array.get(164) + "'," +
                            "'" + array.get(165) + "'," +
                            "'" + array.get(166) + "'," +
                            "'" + array.get(167) + "'," +
                            "'" + array.get(168) + "'," +
                            "'" + array.get(169) + "'); ");	out.newLine(); out.flush();
                }
                //成本-增值银商-数字营销
                if(j==170 &j<=182) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','增值银商','数字营销'," +
                            "'" + array.get(170) + "'," +
                            "'" + array.get(171) + "'," +
                            "'" + array.get(172) + "'," +
                            "'" + array.get(173) + "'," +
                            "'" + array.get(174) + "'," +
                            "'" + array.get(175) + "'," +
                            "'" + array.get(176) + "'," +
                            "'" + array.get(177) + "'," +
                            "'" + array.get(178) + "'," +
                            "'" + array.get(179) + "'," +
                            "'" + array.get(180) + "'," +
                            "'" + array.get(181) + "'," +
                            "'" + array.get(182) + "'); ");	out.newLine(); out.flush();
                }
                //成本-增值银商-广告服务
                if(j==183 &j<=195) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','增值银商','广告服务'," +
                            "'" + array.get(183) + "'," +
                            "'" + array.get(184) + "'," +
                            "'" + array.get(185) + "'," +
                            "'" + array.get(186) + "'," +
                            "'" + array.get(187) + "'," +
                            "'" + array.get(188) + "'," +
                            "'" + array.get(189) + "'," +
                            "'" + array.get(190) + "'," +
                            "'" + array.get(191) + "'," +
                            "'" + array.get(192) + "'," +
                            "'" + array.get(193) + "'," +
                            "'" + array.get(194) + "'," +
                            "'" + array.get(195) + "'); ");	out.newLine(); out.flush();
                }
                //成本-增值银商-数字终端产品
                if(j==196 &j<=208) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','增值银商','数字终端产品'," +
                            "'" + array.get(196) + "'," +
                            "'" + array.get(197) + "'," +
                            "'" + array.get(198) + "'," +
                            "'" + array.get(199) + "'," +
                            "'" + array.get(200) + "'," +
                            "'" + array.get(201) + "'," +
                            "'" + array.get(202) + "'," +
                            "'" + array.get(203) + "'," +
                            "'" + array.get(204) + "'," +
                            "'" + array.get(205) + "'," +
                            "'" + array.get(206) + "'," +
                            "'" + array.get(207) + "'," +
                            "'" + array.get(208) + "'); ");	out.newLine(); out.flush();
                }
                //成本-增值银商-收款运营
                if(j==209 &j<=221) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','增值银商','收款运营'," +
                            "'" + array.get(209) + "'," +
                            "'" + array.get(210) + "'," +
                            "'" + array.get(211) + "'," +
                            "'" + array.get(212) + "'," +
                            "'" + array.get(213) + "'," +
                            "'" + array.get(214) + "'," +
                            "'" + array.get(215) + "'," +
                            "'" + array.get(216) + "'," +
                            "'" + array.get(217) + "'," +
                            "'" + array.get(218) + "'," +
                            "'" + array.get(219) + "'," +
                            "'" + array.get(220) + "'," +
                            "'" + array.get(221) + "'); ");	out.newLine(); out.flush();
                }
                //成本-增值银商-结算增值
                if(j==222 &j<=234) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','增值银商','结算增值'," +
                            "'" + array.get(222) + "'," +
                            "'" + array.get(223) + "'," +
                            "'" + array.get(224) + "'," +
                            "'" + array.get(225) + "'," +
                            "'" + array.get(226) + "'," +
                            "'" + array.get(227) + "'," +
                            "'" + array.get(228) + "'," +
                            "'" + array.get(229) + "'," +
                            "'" + array.get(230) + "'," +
                            "'" + array.get(231) + "'," +
                            "'" + array.get(232) + "'," +
                            "'" + array.get(233) + "'," +
                            "'" + array.get(234) + "'); ");	out.newLine(); out.flush();
                }
                    //成本-增值银商-金融信息
                    if(j==235 &j<=247) {
                        out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                                "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                                "VALUES('" + array.get(0) + "','成本','增值银商','金融信息'," +
                                "'" + array.get(235) + "'," +
                                "'" + array.get(236) + "'," +
                                "'" + array.get(237) + "'," +
                                "'" + array.get(238) + "'," +
                                "'" + array.get(239) + "'," +
                                "'" + array.get(240) + "'," +
                                "'" + array.get(241) + "'," +
                                "'" + array.get(242) + "'," +
                                "'" + array.get(243) + "'," +
                                "'" + array.get(244) + "'," +
                                "'" + array.get(245) + "'," +
                                "'" + array.get(246) + "'," +
                                "'" + array.get(247) + "'); ");	out.newLine(); out.flush();
                    }
//                //成本-科技银商-软件销售
                if(j==248 &j<=260) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','科技银商','ERP服务'," +
                            "'" + array.get(248) + "'," +
                            "'" + array.get(249) + "'," +
                            "'" + array.get(250) + "'," +
                            "'" + array.get(251) + "'," +
                            "'" + array.get(252) + "'," +
                            "'" + array.get(253) + "'," +
                            "'" + array.get(254) + "'," +
                            "'" + array.get(255) + "'," +
                            "'" + array.get(256) + "'," +
                            "'" + array.get(257) + "'," +
                            "'" + array.get(258) + "'," +
                            "'" + array.get(259) + "'," +
                            "'" + array.get(260) + "'); ");	out.newLine(); out.flush();
                }
                //成本-科技银商-大数据服务
                if(j==261 &j<=273) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','科技银商','大数据服务'," +
                            "'" + array.get(261) + "'," +
                            "'" + array.get(262) + "'," +
                            "'" + array.get(263) + "'," +
                            "'" + array.get(264) + "'," +
                            "'" + array.get(265) + "'," +
                            "'" + array.get(266) + "'," +
                            "'" + array.get(267) + "'," +
                            "'" + array.get(268) + "'," +
                            "'" + array.get(269) + "'," +
                            "'" + array.get(270) + "'," +
                            "'" + array.get(271) + "'," +
                            "'" + array.get(272) + "'," +
                            "'" + array.get(273) + "'); ");	out.newLine(); out.flush();
                }
//                成本-科技银商-技术服务
                if(j==274 &j<=286) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','科技银商','数字经营与信息化解决方案'," +
                            "'" + array.get(274) + "'," +
                            "'" + array.get(275) + "'," +
                            "'" + array.get(276) + "'," +
                            "'" + array.get(277) + "'," +
                            "'" + array.get(278) + "'," +
                            "'" + array.get(279) + "'," +
                            "'" + array.get(280) + "'," +
                            "'" + array.get(281) + "'," +
                            "'" + array.get(282) + "'," +
                            "'" + array.get(283) + "'," +
                            "'" + array.get(284) + "'," +
                            "'" + array.get(285) + "'," +
                            "'" + array.get(286) + "'); ");	out.newLine(); out.flush();
                }
              //  成本-科技银商-IDC及云服务
                if(j==287 &j<=299) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','科技银商','IDC及云服务'," +
                            "'" + array.get(287) + "'," +
                            "'" + array.get(288) + "'," +
                            "'" + array.get(289) + "'," +
                            "'" + array.get(290) + "'," +
                            "'" + array.get(291) + "'," +
                            "'" + array.get(292)+ "'," +
                            "'" + array.get(293) + "'," +
                            "'" + array.get(294) + "'," +
                            "'" + array.get(295) + "'," +
                            "'" + array.get(296) + "'," +
                            "'" + array.get(297) + "'," +
                            "'" + array.get(298) + "'," +
                            "'" + array.get(299) + "'); ");	out.newLine(); out.flush();
                }


                //成本-'其他业务','其他业务',"
                if(j==301 &j<=313) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','其他业务','其他业务','其他业务'," +
                            "'" + array.get(301) + "'," +
                            "'" + array.get(302) + "'," +
                            "'" + array.get(303) + "'," +
                            "'" + array.get(304) + "'," +
                            "'" + array.get(305) + "'," +
                            "'" + array.get(306) + "'," +
                            "'" + array.get(307) + "'," +
                            "'" + array.get(308) + "'," +
                            "'" + array.get(309) + "'," +
                            "'" + array.get(310) + "'," +
                            "'" + array.get(311) + "'," +
                            "'" + array.get(312) + "'," +
                            "'" + array.get(313) + "'); ");	out.newLine(); out.flush();
                }



                if(j==314 &j<=326) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','其他业务','其他业务','总公司内部计价'," +
                            "'" + array.get(314) + "'," +
                            "'" + array.get(315) + "'," +
                            "'" + array.get(316) + "'," +
                            "'" + array.get(317) + "'," +
                            "'" + array.get(318) + "'," +
                            "'" + array.get(319) + "'," +
                            "'" + array.get(320) + "'," +
                            "'" + array.get(321) + "'," +
                            "'" + array.get(322) + "'," +
                            "'" + array.get(323) + "'," +
                            "'" + array.get(324) + "'," +
                            "'" + array.get(325) + "'," +
                            "'" + array.get(326) + "'); ");	out.newLine(); out.flush();
                }


                if(j==328 &j<=343) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','成本','其他业务','成本总计（不含营销联盟）','成本总计（不含营销联盟）'," +
                            "'" + array.get(328) + "'," +
                            "'" + array.get(329) + "'," +
                            "'" + array.get(330) + "'," +
                            "'" + array.get(331) + "'," +
                            "'" + array.get(332)+ "'," +
                            "'" + array.get(333) + "'," +
                            "'" + array.get(334) + "'," +
                            "'" + array.get(335) + "'," +
                            "'" + array.get(336) + "'," +
                            "'" + array.get(337) + "'," +
                            "'" + array.get(338) + "'," +
                            "'" + array.get(339) + "'," +
                            "'" + array.get(340) + "'); ");	out.newLine(); out.flush();
                }

            }
        }
    }
    /**
     * 作者 LYC
     * 时间 2022/8/23 18:12
     * 参数 [list]
     * 返回值 void
     *方法描述：费用
     **/
    public static void sheetfy(ArrayList<ArrayList<String>> list,BufferedWriter out) throws IOException {

        for (int i = 9; i < list.size(); i++) {
            System.out.println("************"+i);
            ArrayList<String> array=list.get(i);
            for (int j = 0; j < array.size(); j++) {
                //费用-人力成本
                if(j==1 &j<=13) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','费用','人力成本'," +
                            "'" + array.get(1) + "'," +
                            "'" + array.get(2) + "'," +
                            "'" + array.get(3) + "'," +
                            "'" + array.get(4) + "'," +
                            "'" + array.get(5) + "'," +
                            "'" + array.get(6) + "'," +
                            "'" + array.get(7) + "'," +
                            "'" + array.get(8) + "'," +
                            "'" + array.get(9) + "'," +
                            "'" + array.get(10) + "'," +
                            "'" + array.get(11) + "'," +
                            "'" + array.get(12) + "'," +
                            "'" + array.get(13) + "'); ");
                    out.newLine(); out.flush();
                }
                //费用-差旅费、办公费、交通费等
                if(j==14 &j<=26) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','费用','差旅费、办公费、交通费等'," +
                            "'" + array.get(14) + "'," +
                            "'" + array.get(15) + "'," +
                            "'" + array.get(16) + "'," +
                            "'" + array.get(17) + "'," +
                            "'" + array.get(18) + "'," +
                            "'" + array.get(19) + "'," +
                            "'" + array.get(20) + "'," +
                            "'" + array.get(21) + "'," +
                            "'" + array.get(22) + "'," +
                            "'" + array.get(23) + "'," +
                            "'" + array.get(24) + "'," +
                            "'" + array.get(25) + "'," +
                            "'" + array.get(26) + "'); ");
                    out.newLine(); out.flush();
                }
                //费用-房租、水电、物管等
                if(j==27 &j<=39) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','费用','费用分摊'," +
                            "'" + array.get(27) + "'," +
                            "'" + array.get(28) + "'," +
                            "'" + array.get(29) + "'," +
                            "'" + array.get(30) + "'," +
                            "'" + array.get(31) + "'," +
                            "'" + array.get(32) + "'," +
                            "'" + array.get(33) + "'," +
                            "'" + array.get(34) + "'," +
                            "'" + array.get(35) + "'," +
                            "'" + array.get(36) + "'," +
                            "'" + array.get(37) + "'," +
                            "'" + array.get(38) + "'," +
                            "'" + array.get(39) + "'); ");
                    out.newLine(); out.flush();
                }
                //费用-邮电费
                if(j==40 &j<=52) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','费用','招待费'," +
                            "'" + array.get(40) + "'," +
                            "'" + array.get(41) + "'," +
                            "'" + array.get(42) + "'," +
                            "'" + array.get(43) + "'," +
                            "'" + array.get(44) + "'," +
                            "'" + array.get(45) + "'," +
                            "'" + array.get(46) + "'," +
                            "'" + array.get(47) + "'," +
                            "'" + array.get(48) + "'," +
                            "'" + array.get(49) + "'," +
                            "'" + array.get(50) + "'," +
                            "'" + array.get(51) + "'," +
                            "'" + array.get(52) + "'); ");
                    out.newLine(); out.flush();
                }
                //费用-资金内部计价
                if(j==53 &j<=65) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','费用','房租、水电、物管等'," +
                            "'" + array.get(53) + "'," +
                            "'" + array.get(54) + "'," +
                            "'" + array.get(55) + "'," +
                            "'" + array.get(56) + "'," +
                            "'" + array.get(57) + "'," +
                            "'" + array.get(58) + "'," +
                            "'" + array.get(59) + "'," +
                            "'" + array.get(60) + "'," +
                            "'" + array.get(61) + "'," +
                            "'" + array.get(62) + "'," +
                            "'" + array.get(63) + "'," +
                            "'" + array.get(64) + "'," +
                            "'" + array.get(65) + "'); ");
                    out.newLine(); out.flush();
                }
                //费用-营销费
                if(j==66 &j<=78) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','费用','邮电费'," +
                            "'" + array.get(66) + "'," +
                            "'" + array.get(67) + "'," +
                            "'" + array.get(68) + "'," +
                            "'" + array.get(69) + "'," +
                            "'" + array.get(70) + "'," +
                            "'" + array.get(71) + "'," +
                            "'" + array.get(72) + "'," +
                            "'" + array.get(73) + "'," +
                            "'" + array.get(74) + "'," +
                            "'" + array.get(75) + "'," +
                            "'" + array.get(76) + "'," +
                            "'" + array.get(77) + "'," +
                            "'" + array.get(78) + "'); ");
                    out.newLine(); out.flush();
                }
                if(j==79 &j<=91) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','费用','资金内部计价'," +
                            "'" + array.get(79) + "'," +
                            "'" + array.get(80) + "'," +
                            "'" + array.get(81) + "'," +
                            "'" + array.get(82) + "'," +
                            "'" + array.get(83) + "'," +
                            "'" + array.get(84) + "'," +
                            "'" + array.get(85) + "'," +
                            "'" + array.get(86) + "'," +
                            "'" + array.get(87) + "'," +
                            "'" + array.get(88) + "'," +
                            "'" + array.get(89) + "'," +
                            "'" + array.get(90) + "'," +
                            "'" + array.get(91) + "'); ");
                    out.newLine(); out.flush();
                }
                if(j==92 &j<=104) {
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('" + array.get(0) + "','费用','营销费'," +
                            "'" + array.get(92) + "'," +
                            "'" + array.get(93) + "'," +
                            "'" + array.get(94) + "'," +
                            "'" + array.get(95) + "'," +
                            "'" + array.get(96) + "'," +
                            "'" + array.get(97) + "'," +
                            "'" + array.get(98) + "'," +
                            "'" + array.get(99) + "'," +
                            "'" + array.get(100) + "'," +
                            "'" + array.get(101) + "'," +
                            "'" + array.get(102) + "'," +
                            "'" + array.get(103) + "'," +
                            "'" + array.get(104) + "'); ");
                    out.newLine(); out.flush();
                }
            }
        }
    }
    /**
     * 作者 LYC
     * 时间 2022/8/23 18:12
     * 参数 [list]
     * 返回值 void
     *方法描述：去年同期
     **/
    public static void sheetqntq(ArrayList<ArrayList<String>> list,BufferedWriter out) throws IOException {
        for (int i = 2; i < list.size(); i++) {
            ArrayList<String> array=list.get(i);
            for (int j = 0; j < array.size(); j++) {
                //收单互联网
                if(j==1) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(1) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='收单(互联网)' AND index_type='收入' AND PRODUCT_SUB='线上支付';");out.newLine(); out.flush();
                }
                      //线上代收付
                if(j==2) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(2) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='财税库银' AND index_type='收入' AND PRODUCT_SUB='线上支付';");out.newLine(); out.flush();
                }
                      //线上代收付
                if(j==3) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(3) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='代收付' AND index_type='收入' AND PRODUCT_SUB='线上支付';");out.newLine(); out.flush();
                }
                      //线上支付 会计报名
                if(j==4) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(4) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='会计报名' AND index_type='收入' AND PRODUCT_SUB='线上支付';");out.newLine(); out.flush();
                }

                       //线上支付 移动远程支付
                if(j==5) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(5) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='移动远程支付' AND index_type='收入' AND PRODUCT_SUB='线上支付';");out.newLine(); out.flush();
                }

                       //线下支付 收单银行卡
                if(j==6) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(6) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='收单(银行卡、信宝)' AND index_type='收入' AND PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }
                      //线下支付 财税库银
                if(j==7) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(7) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='财税库银' AND index_type='收入' AND PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }

                       //线下支付 预付卡
                if(j==8) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(8) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='预付卡' AND index_type='收入' AND PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }

                       // 线下支付 拓展服务-信宝返佣
                if(j==9) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(9) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='拓展服务-信宝返佣' AND index_type='收入' AND PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }
                      //增值银商- 客户及终端专业化
                if(j==10) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(10) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='客户及终端专业化' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }
                      //                增值银商- 拓展服务-其他
                if(j==11) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(11) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='拓展服务-其他' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }
                      //              增值银商- 拓展服务-其他
                if(j==12) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(12) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='ATM专业化' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }

                       //              增值银商- 广告服务
                if(j==13) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(13) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='广告服务' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }

                       //             增值银商- 数字营销
                if(j==14) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(14) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='数字营销' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }
                      //增值银商- 数字终端产品
                if(j==15) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(15) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='数字终端产品' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }

                       //增值银商- 收款运营
                if(j==16) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(16) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='收款运营' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }

                       //增值银商- 结算增值
                if(j==17) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(17) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='结算增值' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }

                       // 增值银商- 金融信息
                if(j==18) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(18) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='金融信息' AND index_type='收入' AND PRODUCT_TYPE='增值银商';");out.newLine(); out.flush();
                }

                       //科技银商- 软件销售
                if(j==19) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(19) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='ERP服务' AND index_type='收入' AND PRODUCT_TYPE='科技银商';");out.newLine(); out.flush();
                }
                      // 科技银商- 大数据服务
                if(j==20) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(20) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='大数据服务' AND index_type='收入' AND PRODUCT_TYPE='科技银商';");out.newLine(); out.flush();
                }



                       // 科技银商- 物流服务
                if(j==21) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(21) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND PRODUCT_SUBCLASS='数字经营与信息化解决方案' AND index_type='收入' AND PRODUCT_TYPE='科技银商';");out.newLine(); out.flush();
                }

                       // 成本 支付银商- 线上支付-代收付
                if(j==22) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(22) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='财税库银' AND index_type='成本' AND PRODUCT_TYPE='支付银商' and PRODUCT_SUB='线上支付';");out.newLine(); out.flush();
                }

                       //成本 支付银商- 线上支付-财税库银
                if(j==23) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(23) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='代收付' AND index_type='成本' AND PRODUCT_TYPE='支付银商' and PRODUCT_SUB='线上支付';");out.newLine(); out.flush();
                }

                       // 成本 支付银商- 线上支付-发卡、银联网络服务费
                if(j==24) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(24) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='发卡、银联网络服务费' AND index_type='成本' AND PRODUCT_TYPE='支付银商' and PRODUCT_SUB='线上支付';");out.newLine(); out.flush();
                }

                       // 成本 支付银商- 线下支付-品牌费
                if(j==25) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(25) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='品牌费' AND index_type='成本' AND PRODUCT_TYPE='支付银商' and PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }
                      //成本 支付银商- 线下支付-财税库银
                if(j==26) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(26) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='财税库银' AND index_type='成本' AND PRODUCT_TYPE='支付银商' and PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }
                      //成本 支付银商- 线下支付-分润成本
                if(j==27) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(27) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='分润成本' AND index_type='成本' AND PRODUCT_TYPE='支付银商' and PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }

                       //成本 支付银商- 线下支付-预付卡
                if(j==28) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(28) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='预付卡' AND index_type='成本' AND PRODUCT_TYPE='支付银商' and PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }

                       //成本 支付银商- 线下支付-机具折旧等
                if(j==29) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(29) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='机具折旧等' AND index_type='成本' AND PRODUCT_TYPE='支付银商' and PRODUCT_SUB='线下支付';");out.newLine(); out.flush();
                }

                       // 成本 增值银商- 耗材配件
                if(j==30) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(30) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='耗材配件' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       // 成本 增值银商- 通讯成本等
                if(j==31) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(31) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='通讯成本等' AND index_type='成本' AND PRODUCT_TYPE='支付银商' ;");out.newLine(); out.flush();
                }

                       //成本 增值银商- 拓展服务-其他
                if(j==32) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(32) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='拓展服务-其他' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       //成本 增值银商- ATM专业化
                if(j==33) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(33) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='ATM专业化' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       // 成本 增值银商- 广告服务
                if(j==34) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(34) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='数字营销' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       //成本 增值银商- 数字营销
                if(j==35) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(35) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='广告服务' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       // 成本 增值银商- 数字终端产品
                if(j==36) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(36) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='数字终端产品' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       // 成本 增值银商- 收款运营
                if(j==37) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(37) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='收款运营' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       // 成本 增值银商- 结算增值
                if(j==38) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(38) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='结算增值' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       //成本 增值银商- 金融信息
                if(j==39) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(39) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='金融信息' AND index_type='成本' AND PRODUCT_TYPE='增值银商' ;");out.newLine(); out.flush();
                }

                       //  成本 科技银商- 软件销售
                if(j==40) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(40) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='ERP服务' AND index_type='成本' AND PRODUCT_TYPE='科技银商' ;");out.newLine(); out.flush();
                }

                       //成本 科技银商- 大数据服务
                if(j==41) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(41) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='大数据服务' AND index_type='成本' AND PRODUCT_TYPE='科技银商' ;");out.newLine(); out.flush();
                }
                      // 成本 科技银商- 技术服务
                if(j==42) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(42) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  PRODUCT_SUBCLASS='数字经营与信息化解决方案' AND index_type='成本' AND PRODUCT_TYPE='科技银商' ;");out.newLine(); out.flush();
                }

                       // 费用 人力成本
                if(j==43) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(43) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  index_type='费用'  AND PRODUCT_TYPE='人力成本';");out.newLine(); out.flush();
                }

                       // 费用 差旅费、办公费、交通费等
                if(j==44) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(44) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  index_type='费用'  AND PRODUCT_TYPE='差旅费、办公费、交通费等';");out.newLine(); out.flush();
                }

                       // 费用 房租、水电、物管等
                if(j==45) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(45) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  index_type='费用'  AND PRODUCT_TYPE='房租、水电、物管等';");out.newLine(); out.flush();
                }

                       // 费用 邮电费
                if(j==46) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(46) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  index_type='费用'  AND PRODUCT_TYPE='邮电费';");out.newLine(); out.flush();
                }
                      //费用 资金内部计价
                if(j==47) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(47) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  index_type='费用'  AND PRODUCT_TYPE='资金内部计价';");out.newLine(); out.flush();
                }

                       // 费用 营销费
                if(j==48) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(48) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  index_type='费用'  AND PRODUCT_TYPE='营销费';");out.newLine(); out.flush();
                }
                      //净利润
                if(j==49) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(49) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  index_type='费用'   AND  PRODUCT_TYPE='费用分摊' ;");out.newLine(); out.flush();
                }
                if(j==50) {
                    out.write("UPDATE DEPT_ACHIEVEMENTS SET " +
                            "CORRESPONDING='" + array.get(50) + "' " +
                            "WHERE DEPT_NAME='" + array.get(0) + "' AND  index_type='费用' AND  PRODUCT_TYPE='招待费' ;");out.newLine(); out.flush();
                }
                  }
        }
    }
    /**
     * 作者 LYC
     * 时间 2022/8/23 18:12
     * 参数 [list]
     * 返回值 void
     *方法描述：产品计价
     **/
    public static void sheetqncpjj(ArrayList<ArrayList<String>> list,BufferedWriter out) throws IOException {

        for (int i = 1; i < list.size(); i++) {
            ArrayList<String> array=list.get(i);
            out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE," +
                    "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                    "VALUES('"+array.get(0)+"','产品计价奖励'," +
                    "'"+array.get(1)+"'" +
                    ",'"+array.get(2)+"'" +
                    ",'"+array.get(3)+"'" +
                    ",'"+array.get(4)+"'" +
                    ",'"+array.get(5)+"'" +
                    ",'"+array.get(6)+"'" +
                    ",'"+array.get(7)+"'" +
                    ",'"+array.get(8)+"'" +
                    ",'"+array.get(9)+"'" +
                    ",'"+array.get(10)+"'" +
                    ",'"+array.get(11)+"'" +
                    ",'"+array.get(12)+"'" +
                    ",'"+array.get(13)+"'" +
                    ");");
            out.newLine();
            out.flush();
        }
        out.close();
    }
    /**
     * 作者 LYC
     * 时间 2022/8/23 18:09
     * 参数 [list]
    * 返回值 void
     *方法描述：Sheet0 收入
    **/
    public static void sheetSR(ArrayList<ArrayList<String>> list,BufferedWriter out) throws IOException {
        //从第5行开始
        for (int i = 5; i < list.size(); i++) {
            ArrayList<String> array=list.get(i);
            System.out.println("************&&&&&&&&**********"+array.size());
            for (int j = 0; j < array.size(); j++) {
                if(j==7 && j<=8){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,BUDGET,CHRONOLOGY," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) VALUES('"+array.get(0)+"'," +
                            "'净利润','"+ array.get(7) +"','" +
                            ""+array.get(8)+"'," +
                            "'"+array.get(9)+"'," +
                            "'"+array.get(10)+"'," +
                            "'"+array.get(11)+"'," +
                            "'"+array.get(12)+"'," +
                            "'"+array.get(13)+"'," +
                            "'"+array.get(14)+"'," +
                            "'"+array.get(15)+"'," +
                            "'"+array.get(16)+"'," +
                            "'"+array.get(17)+"'," +
                            "'"+array.get(18)+"'," +
                            "'"+array.get(19)+"'," +
                            "'"+array.get(20)+"'," +
                            "'"+array.get(21)+"'); ");
                    out.newLine(); out.flush();
                }
              //  收入-支付银商-线上支付-收单互联网
                if(j==75 && j<=87){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线上支付','收单(互联网)'," +
                            "'"+array.get(75)+"'," +
                            "'"+array.get(76)+"'," +
                            "'"+array.get(77)+"'," +
                            "'"+array.get(78)+"'," +
                            "'"+array.get(79)+"'," +
                            "'"+array.get(80)+"'," +
                            "'"+array.get(81)+"'," +
                            "'"+array.get(82)+"'," +
                            "'"+array.get(83)+"'," +
                            "'"+array.get(84)+"'," +
                            "'"+array.get(85)+"'," +
                            "'"+array.get(86)+"'," +
                            "'"+array.get(87)+"'); ");
                    out.newLine(); out.flush();
                }
//                收入-支付银商-线上支付-代收付
                 if(j==101 && j<=113){
                     out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线上支付','代收付'," +
                            "'"+array.get(101)+"'," +
                            "'"+array.get(102)+"'," +
                            "'"+array.get(103)+"'," +
                            "'"+array.get(104)+"'," +
                            "'"+array.get(105)+"'," +
                            "'"+array.get(106)+"'," +
                            "'"+array.get(107)+"'," +
                            "'"+array.get(108)+"'," +
                            "'"+array.get(109)+"'," +
                            "'"+array.get(110)+"'," +
                            "'"+array.get(111)+"'," +
                            "'"+array.get(112)+"'," +
                            "'"+array.get(113)+"'); ");
                     out.newLine(); out.flush();
                }
//                收入-支付银商-线上支付-财税库银
                if(j==88 && j<=100){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线上支付','财税库银'," +
                            "'"+array.get(88)+"'," +
                            "'"+array.get(89)+"'," +
                            "'"+array.get(90)+"'," +
                            "'"+array.get(91)+"'," +
                            "'"+array.get(92)+"'," +
                            "'"+array.get(93)+"'," +
                            "'"+array.get(94)+"'," +
                            "'"+array.get(95)+"'," +
                            "'"+array.get(96)+"'," +
                            "'"+array.get(97)+"'," +
                            "'"+array.get(98)+"'," +
                            "'"+array.get(99)+"'," +
                            "'"+array.get(100)+"'); ");
                    out.newLine(); out.flush();
                }
//                收入-支付银商-线上支付-会计报名
                if(j==114 && j<=126){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线上支付','会计报名'," +
                            "'"+array.get(114)+"'," +
                            "'"+array.get(115)+"'," +
                            "'"+array.get(116)+"'," +
                            "'"+array.get(117)+"'," +
                            "'"+array.get(118)+"'," +
                            "'"+array.get(119)+"'," +
                            "'"+array.get(120)+"'," +
                            "'"+array.get(121)+"'," +
                            "'"+array.get(122)+"'," +
                            "'"+array.get(123)+"'," +
                            "'"+array.get(124)+"'," +
                            "'"+array.get(125)+"'," +
                            "'"+array.get(126)+"'); ");
                    out.newLine(); out.flush();
                }
//                收入-支付银商-线上支付-移动远程支付
                if(j==127 && j<=139){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线上支付','移动远程支付'," +
                            "'"+array.get(127)+"'," +
                            "'"+array.get(128)+"'," +
                            "'"+array.get(129)+"'," +
                            "'"+array.get(130)+"'," +
                            "'"+array.get(131)+"'," +
                            "'"+array.get(132)+"'," +
                            "'"+array.get(133)+"'," +
                            "'"+array.get(134)+"'," +
                            "'"+array.get(135)+"'," +
                            "'"+array.get(136)+"'," +
                            "'"+array.get(137)+"'," +
                            "'"+array.get(138)+"'," +
                            "'"+array.get(139)+"'); ");	out.newLine(); out.flush();
                }

//                收入-支付银商-线下支付-收单(银行卡、信宝)
                if(j==22 && j<=34){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线下支付','收单(银行卡、信宝)'," +
                            "'"+array.get(22)+"'," +
                            "'"+array.get(23)+"'," +
                            "'"+array.get(24)+"'," +
                            "'"+array.get(25)+"'," +
                            "'"+array.get(26)+"'," +
                            "'"+array.get(27)+"'," +
                            "'"+array.get(28)+"'," +
                            "'"+array.get(29)+"'," +
                            "'"+array.get(30)+"'," +
                            "'"+array.get(31)+"'," +
                            "'"+array.get(32)+"'," +
                            "'"+array.get(33)+"'," +
                            "'"+array.get(34)+"'); ");	out.newLine(); out.flush();
                }
                //  收入-支付银商-线下支付-财税库银
                if(j==35 && j<=47){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线下支付','财税库银'," +
                            "'"+array.get(35)+"'," +
                            "'"+array.get(36)+"'," +
                            "'"+array.get(37)+"'," +
                            "'"+array.get(38)+"'," +
                            "'"+array.get(39)+"'," +
                            "'"+array.get(40)+"'," +
                            "'"+array.get(41)+"'," +
                            "'"+array.get(42)+"'," +
                            "'"+array.get(43)+"'," +
                            "'"+array.get(44)+"'," +
                            "'"+array.get(45)+"'," +
                            "'"+array.get(46)+"'," +
                            "'"+array.get(47)+"'); ");	out.newLine(); out.flush();
                }

                //  收入-支付银商-线下支付-预付卡
                if(j==48 && j<=60){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线下支付','预付卡'," +
                            "'"+array.get(48)+"'," +
                            "'"+array.get(49)+"'," +
                            "'"+array.get(50)+"'," +
                            "'"+array.get(51)+"'," +
                            "'"+array.get(52)+"'," +
                            "'"+array.get(53)+"'," +
                            "'"+array.get(54)+"'," +
                            "'"+array.get(55)+"'," +
                            "'"+array.get(56)+"'," +
                            "'"+array.get(57)+"'," +
                            "'"+array.get(58)+"'," +
                            "'"+array.get(59)+"'," +
                            "'"+array.get(60)+"'); ");	out.newLine(); out.flush();
                }
                // 收入-支付银商-线下支付-拓展服务-信宝返佣
                if(j==61 && j<=73){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUB,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','线下支付','拓展服务-信宝返佣'," +
                            "'"+array.get(61)+"'," +
                            "'"+array.get(62)+"'," +
                            "'"+array.get(63)+"'," +
                            "'"+array.get(64)+"'," +
                            "'"+array.get(65)+"'," +
                            "'"+array.get(66)+"'," +
                            "'"+array.get(67)+"'," +
                            "'"+array.get(68)+"'," +
                            "'"+array.get(69)+"'," +
                            "'"+array.get(70)+"'," +
                            "'"+array.get(71)+"'," +
                            "'"+array.get(72)+"'," +
                            "'"+array.get(73)+"'); ");	out.newLine(); out.flush();
                }
                //  收入-增值银商--客户及终端专业化
                if(j==142 && j<=154){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','客户及终端专业化'," +
                            "'"+array.get(142)+"'," +
                            "'"+array.get(143)+"'," +
                            "'"+array.get(144)+"'," +
                            "'"+array.get(145)+"'," +
                            "'"+array.get(146)+"'," +
                            "'"+array.get(147)+"'," +
                            "'"+array.get(148)+"'," +
                            "'"+array.get(149)+"'," +
                            "'"+array.get(150)+"'," +
                            "'"+array.get(151)+"'," +
                            "'"+array.get(152)+"'," +
                            "'"+array.get(153)+"'," +
                            "'"+array.get(154)+"'); ");	out.newLine(); out.flush();
                }
                //   收入-增值银商--拓展服务-其他
                if(j==155 && j<=167){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','拓展服务-其他'," +
                            "'"+array.get(155)+"'," +
                            "'"+array.get(156)+"'," +
                            "'"+array.get(157)+"'," +
                            "'"+array.get(158)+"'," +
                            "'"+array.get(159)+"'," +
                            "'"+array.get(160)+"'," +
                            "'"+array.get(161)+"'," +
                            "'"+array.get(162)+"'," +
                            "'"+array.get(163)+"'," +
                            "'"+array.get(164)+"'," +
                            "'"+array.get(165)+"'," +
                            "'"+array.get(166)+"'," +
                            "'"+array.get(167)+"'); ");	out.newLine(); out.flush();
                }
                //收入-增值银商--ATM专业化
                if(j==168 && j<=180){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','ATM专业化'," +
                            "'"+array.get(168)+"'," +
                            "'"+array.get(169)+"'," +
                            "'"+array.get(170)+"'," +
                            "'"+array.get(171)+"'," +
                            "'"+array.get(172)+"'," +
                            "'"+array.get(173)+"'," +
                            "'"+array.get(174)+"'," +
                            "'"+array.get(175)+"'," +
                            "'"+array.get(176)+"'," +
                            "'"+array.get(177)+"'," +
                            "'"+array.get(178)+"'," +
                            "'"+array.get(179)+"'," +
                            "'"+array.get(180)+"'); ");	out.newLine(); out.flush();
                }
                //收入-增值银商--广告服务
                if(j==181 && j<=193){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','广告服务'," +
                            "'"+array.get(181)+"'," +
                            "'"+array.get(182)+"'," +
                            "'"+array.get(183)+"'," +
                            "'"+array.get(184)+"'," +
                            "'"+array.get(185)+"'," +
                            "'"+array.get(186)+"'," +
                            "'"+array.get(187)+"'," +
                            "'"+array.get(188)+"'," +
                            "'"+array.get(189)+"'," +
                            "'"+array.get(190)+"'," +
                            "'"+array.get(191)+"'," +
                            "'"+array.get(192)+"'," +
                            "'"+array.get(193)+"'); ");	out.newLine(); out.flush();
                }
                //收入-增值银商--数字营销
                if(j==194 && j<=206){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','数字营销'," +
                            "'"+array.get(194)+"'," +
                            "'"+array.get(195)+"'," +
                            "'"+array.get(196)+"'," +
                            "'"+array.get(197)+"'," +
                            "'"+array.get(198)+"'," +
                            "'"+array.get(199)+"'," +
                            "'"+array.get(200)+"'," +
                            "'"+array.get(201)+"'," +
                            "'"+array.get(202)+"'," +
                            "'"+array.get(203)+"'," +
                            "'"+array.get(204)+"'," +
                            "'"+array.get(205)+"'," +
                            "'"+array.get(206)+"'); ");	out.newLine(); out.flush();
                }
                //收入-增值银商--数字终端产品
                if(j==207 && j<=219){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','数字终端产品'," +
                            "'"+array.get(207)+"'," +
                            "'"+array.get(208)+"'," +
                            "'"+array.get(209)+"'," +
                            "'"+array.get(210)+"'," +
                            "'"+array.get(211)+"'," +
                            "'"+array.get(212)+"'," +
                            "'"+array.get(213)+"'," +
                            "'"+array.get(214)+"'," +
                            "'"+array.get(215)+"'," +
                            "'"+array.get(216)+"'," +
                            "'"+array.get(217)+"'," +
                            "'"+array.get(218)+"'," +
                            "'"+array.get(219)+"'); ");	out.newLine(); out.flush();
                }
                //  收入-增值银商--收款运营
                if(j==220 && j<=232){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','收款运营'," +
                            "'"+array.get(220)+"'," +
                            "'"+array.get(221)+"'," +
                            "'"+array.get(222)+"'," +
                            "'"+array.get(223)+"'," +
                            "'"+array.get(224)+"'," +
                            "'"+array.get(225)+"'," +
                            "'"+array.get(226)+"'," +
                            "'"+array.get(227)+"'," +
                            "'"+array.get(228)+"'," +
                            "'"+array.get(229)+"'," +
                            "'"+array.get(230)+"'," +
                            "'"+array.get(231)+"'," +
                            "'"+array.get(232)+"'); ");	out.newLine(); out.flush();
                }
                //收入-增值银商--结算增值
                if(j==233 && j<=245){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','结算增值'," +
                            "'"+array.get(233)+"'," +
                            "'"+array.get(234)+"'," +
                            "'"+array.get(235)+"'," +
                            "'"+array.get(236)+"'," +
                            "'"+array.get(237)+"'," +
                            "'"+array.get(238)+"'," +
                            "'"+array.get(239)+"'," +
                            "'"+array.get(240)+"'," +
                            "'"+array.get(241)+"'," +
                            "'"+array.get(242)+"'," +
                            "'"+array.get(243)+"'," +
                            "'"+array.get(244)+"'," +
                            "'"+array.get(245)+"'); ");	out.newLine(); out.flush();
                }
                //收入-增值银商--金融信息
                if(j==246 && j<=258){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','增值银商','金融信息'," +
                            "'"+array.get(246)+"'," +
                            "'"+array.get(247)+"'," +
                            "'"+array.get(248)+"'," +
                            "'"+array.get(249)+"'," +
                            "'"+array.get(250)+"'," +
                            "'"+array.get(251)+"'," +
                            "'"+array.get(252)+"'," +
                            "'"+array.get(253)+"'," +
                            "'"+array.get(254)+"'," +
                            "'"+array.get(255)+"'," +
                            "'"+array.get(256)+"'," +
                            "'"+array.get(257)+"'," +
                            "'"+array.get(258)+"'); ");	out.newLine(); out.flush();
                }
                //收入-科技银商--
                if(j==260 && j<=272){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','科技银商','ERP服务'," +
                            "'"+array.get(260)+"'," +
                            "'"+array.get(261)+"'," +
                            "'"+array.get(262)+"'," +
                            "'"+array.get(263)+"'," +
                            "'"+array.get(264)+"'," +
                            "'"+array.get(265)+"'," +
                            "'"+array.get(266)+"'," +
                            "'"+array.get(267)+"'," +
                            "'"+array.get(268)+"'," +
                            "'"+array.get(269)+"'," +
                            "'"+array.get(270)+"'," +
                            "'"+array.get(271)+"'," +
                            "'"+array.get(272)+"'); ");	out.newLine(); out.flush();
                }
                //收入-科技银商--大数据服务
                if(j==273 && j<=285){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','科技银商','大数据服务'," +
                            "'"+array.get(273)+"'," +
                            "'"+array.get(274)+"'," +
                            "'"+array.get(275)+"'," +
                            "'"+array.get(276)+"'," +
                            "'"+array.get(277)+"'," +
                            "'"+array.get(278)+"'," +
                            "'"+array.get(279)+"'," +
                            "'"+array.get(280)+"'," +
                            "'"+array.get(281)+"'," +
                            "'"+array.get(282)+"'," +
                            "'"+array.get(283)+"'," +
                            "'"+array.get(284)+"'," +
                            "'"+array.get(285)+"'); ");	out.newLine(); out.flush();
                }
                //收入-科技银商--技术服务
                if(j==286 && j<=298){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','科技银商','数字经营与信息化解决方案'," +
                            "'"+array.get(286)+"'," +
                            "'"+array.get(287)+"'," +
                            "'"+array.get(288)+"'," +
                            "'"+array.get(289)+"'," +
                            "'"+array.get(290)+"'," +
                            "'"+array.get(291)+"'," +
                            "'"+array.get(292)+"'," +
                            "'"+array.get(293)+"'," +
                            "'"+array.get(294)+"'," +
                            "'"+array.get(295)+"'," +
                            "'"+array.get(296)+"'," +
                            "'"+array.get(297)+"'," +
                            "'"+array.get(298)+"'); ");	out.newLine(); out.flush();
                }
                //收入-科技银商--物流服务
                if(j==299 && j<=311){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','科技银商','IDC及云服务'," +
                            "'"+array.get(299)+"'," +
                            "'"+array.get(300)+"'," +
                            "'"+array.get(301)+"'," +
                            "'"+array.get(302)+"'," +
                            "'"+array.get(303)+"'," +
                            "'"+array.get(304)+"'," +
                            "'"+array.get(305)+"'," +
                            "'"+array.get(306)+"'," +
                            "'"+array.get(307)+"'," +
                            "'"+array.get(308)+"'," +
                            "'"+array.get(309)+"'," +
                            "'"+array.get(310)+"'," +
                            "'"+array.get(311)+"'); ");	out.newLine(); out.flush();
                }
                if(j==313 && j<=325){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','其他业务','其他业务收入'," +
                            "'"+array.get(313)+"'," +
                            "'"+array.get(314)+"'," +
                            "'"+array.get(315)+"'," +
                            "'"+array.get(316)+"'," +
                            "'"+array.get(317)+"'," +
                            "'"+array.get(318)+"'," +
                            "'"+array.get(319)+"'," +
                            "'"+array.get(320)+"'," +
                            "'"+array.get(321)+"'," +
                            "'"+array.get(322)+"'," +
                            "'"+array.get(323)+"'," +
                            "'"+array.get(324)+"'," +
                            "'"+array.get(325)+"'); ");	out.newLine(); out.flush();
                }
                // 收入-科技银商--收入总计
                if(j==1 && j<=2){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,BUDGET,CHRONOLOGY) " +
                            "VALUES('"+array.get(0)+"','收入','收入总计'," +
                            "'"+array.get(1)+"'," +
                            "'"+array.get(2)+"');");	out.newLine(); out.flush();
                }
                //  收入-科技银商--综合收入
                if(j==3 && j<=4){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,BUDGET,CHRONOLOGY) " +
                            "VALUES('"+array.get(0)+"','收入','结构类收入（总公司口径：不含营销联盟考虑内部计价）'," +
                            "'"+array.get(3)+"'," +
                            "'"+array.get(4)+"');");	out.newLine(); out.flush();
                }
                //  收入-科技银商--科技及信息服务
                if(j==5 && j<=6){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,BUDGET,CHRONOLOGY) " +
                            "VALUES('"+array.get(0)+"','收入','科技银商（不考虑内部计价）'," +
                            "'"+array.get(5)+"'," +
                            "'"+array.get(6)+"');");	out.newLine(); out.flush();
                }

                //  收入-科技银商--科技及信息服务

                if(j==326&& j<=327){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,BUDGET,CHRONOLOGY) " +
                            "VALUES('"+array.get(0)+"','收入','增值与科技银商（剔除营销联盟不考虑内部计价）'," +
                            "'"+array.get(326)+"'," +
                            "'"+array.get(327)+"');");out.newLine(); out.flush();

                    }
                if(j==328 && j<=340){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','其他业务','总公司内部计价'," +
                            "'"+array.get(328)+"'," +
                            "'"+array.get(329)+"'," +
                            "'"+array.get(330)+"'," +
                            "'"+array.get(331)+"'," +
                            "'"+array.get(332)+"'," +
                            "'"+array.get(333)+"'," +
                            "'"+array.get(334)+"'," +
                            "'"+array.get(335)+"'," +
                            "'"+array.get(336)+"'," +
                            "'"+array.get(337)+"'," +
                            "'"+array.get(338)+"'," +
                            "'"+array.get(339)+"'," +
                            "'"+array.get(340)+"'); ");	out.newLine(); out.flush();
                }

                if(j==341&& j<=353){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','其他业务','收入总计（不含营销联盟）'," +
                            "'"+array.get(341)+"'," +
                            "'"+array.get(342)+"'," +
                            "'"+array.get(343)+"'," +
                            "'"+array.get(344)+"'," +
                            "'"+array.get(345)+"'," +
                            "'"+array.get(346)+"'," +
                            "'"+array.get(347)+"'," +
                            "'"+array.get(348)+"'," +
                            "'"+array.get(349)+"'," +
                            "'"+array.get(350)+"'," +
                            "'"+array.get(351)+"'," +
                            "'"+array.get(352)+"'," +
                            "'"+array.get(353)+"'); ");	out.newLine(); out.flush();
                }
                if(j==354&& j<=366){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','2023年收单收入'," +
                            "'"+array.get(354)+"'," +
                            "'"+array.get(355)+"'," +
                            "'"+array.get(356)+"'," +
                            "'"+array.get(357)+"'," +
                            "'"+array.get(358)+"'," +
                            "'"+array.get(359)+"'," +
                            "'"+array.get(360)+"'," +
                            "'"+array.get(361)+"'," +
                            "'"+array.get(362)+"'," +
                            "'"+array.get(363)+"'," +
                            "'"+array.get(364)+"'," +
                            "'"+array.get(365)+"'," +
                            "'"+array.get(366)+"'); ");	out.newLine(); out.flush();

                }
                if(j==367&& j<=379){
                    out.write("INSERT INTO DEPT_ACHIEVEMENTS (DEPT_NAME,INDEX_TYPE,PRODUCT_TYPE,PRODUCT_SUBCLASS," +
                            "JANUARY,FEBRUARY,MARCH,APRIL,MAY,JUNE,JULY,AUGUST,SEPTEMBER,OCTOBER,NOVEMBER,DECEMBER,MONTHLYSUM) " +
                            "VALUES('"+array.get(0)+"','收入','支付银商','2021年收单收入'," +
                            "'"+array.get(367)+"'," +
                            "'"+array.get(368)+"'," +
                            "'"+array.get(369)+"'," +
                            "'"+array.get(370)+"'," +
                            "'"+array.get(371)+"'," +
                            "'"+array.get(372)+"'," +
                            "'"+array.get(373)+"'," +
                            "'"+array.get(374)+"'," +
                            "'"+array.get(375)+"'," +
                            "'"+array.get(376)+"'," +
                            "'"+array.get(377)+"'," +
                            "'"+array.get(378)+"'," +
                            "'"+array.get(379)+"'); ");	out.newLine(); out.flush();

                }
            }
        }
        out.close();
    }



}
